To Setup a User Laptop

Install the following software if it has not already been installed:

Oracle Client (for Mixed client only)
Oracle Lite Mobile SDK
Bentley OpenUtilities Designer Workflow Manager with Mobile option

The Client machine (laptop) can be either a mixed client (Access master database and local replicated database) or disconnected only Client (Access only local replicated database).

Note: The following steps must be repeated for each client laptop (user).

Copy the Replication files.
1. Connect to the centralized laptop and copy the following replication files to the respective directories on the client laptop.
  - <Install directory>\Mobile\SDK\OLDB40\POLITE.ODB
  - <Install directory>\Mobile\SDK\OLDB40\CONSROOT.ODB
  - <Install directory>\Mobile\SDK\OLDB40\WEBTOGO.ODB
  - <Install directory>\Mobile\\SDK\OLDB40\<Username>\.CONSCLI.ODB
  - <Install directory>\Mobile\\SDK\OLDB40\<Username>\.<Publication Name>.ODB
Create Oracle Lite ODBC DSNs.
1. Setup the ODBC User DSNs.
  Note: Select "Oracle Lite 40 ODBC Driver v4.00.00.00".
  - Data Source name: POLITE Database Directory: <Install directory>\Mobile\SDK\OLDB40Database: POLITE.ODB Use default values for the remaining options.
  - Data Source name: CONSROOT Database Directory: <Install directory>\Mobile\SDK\OLDB40Database: CONSROOT.ODB Use default values for the remaining options
  - Data Source name: WEBTOGO Database Directory: <Install directory>\Mobile\SDK\OLDB40Database: WEBTOGO.ODB Use default values for the remaining options.
  - Data Source name: <USERNAME>_CONSCLI Database Directory: <Install directory>\Mobile\SDK\OLDB40\<Username>\. Database: CONSCLI.ODB Use default values for the remaining options.
  - Data Source name: <USERNAME>_<Publication Name> Database Directory: <Install directory>\Mobile\SDK\OLDB40\<Username>\. Database: <Publication Name>.ODB Use default values for the remaining options.
Create ODBC DSNs - Both Oracle Client & Lite Installed.
1. Setup the ODBC System DSNs. Note: For CHDATAMASTER select "Oracle in OraDb10g_home1" Driver "v10.02.00.01". For CHDATALITE select "Oracle Lite 40 ODBC Driver v4.00.00.00".
  - Data Source Name: CHDATAMASTER Data Source Service Name: Always points to the Oracle Server SID.
  - Data Source name: CHDATALITE Database Directory: <Install directory from Step1>\Mobile\SDK\OLDB40\<Username> Database: <Publication Name>.ODB.
  Note: Always points to the Oracle Lite SID.
2. Autocommit: ON.
3. Use default values for the remaining options.
Create ODBC DSNs - Oracle Lite Installed.
1. Setup the ODBC System DSN.Note: For CHDATA select "Oracle Lite 40 ODBC Driver v4.00.00.00".
  - Data Source name: CHDATA Database Directory: <Install directory from Step1>\Mobile\SDK\OLDB40\<Username> Database: <Publication Name>.ODB.
  Note: Always points to the Oracle Lite SID.
2. Autocommit: ON.
3. Use default values for the remaining options.
Update the CHConfig.ini file.
1. From..\Program Files\Bentley\UtilitiesDesigner\CHConfig.ini file, set the OracleVer variable equal to OLITE. For Example: OracleVer=OLITE.
Update the Systemtool.dat file.
1. From..\Program Files\Bentley\UtilitiesDesigner\systemtools.dat file, set the ChRepRefresh with the following parameters. Use parameters in the order specified and use a space to separate each value.
2. CHRepRefresh,ChRepRefresh.exe, <Workflow Manager User> <password for Workflow Manager User in Mobile Server> <Mobile Server name>,0,1,.\
3. ED User name of the user who is going to the use the replication database.
  Note: This user name must exist in the Userlogin table of the Master database and in the Mobile Server prior to running the batch file.
4. Password for the above user on the Mobile Server.
5. Host name of the Mobile Server. For Example: CHRepRefresh,ChRepRefresh.exe, administrator chadmin vanuatu,0,1,.\

At this point, you have completed setting up replication on the laptop and are ready to launch Bentley OpenUtilities Designer from the laptop.